Fact.Stock Holding - WideWorldImportersDW

WideWorldImportersDW

- WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Fact
Name	Stock Holding
Module	Stock Holding

Holdings of stock items

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		Stock Holding Key	bigint		Identity		DW key for a row in the Stock Holding fact
DW key for a row in the Stock Holding fact Identity
	2		Stock Item Key	int			Dimension.Stock Item	Stock item being held
Stock item being held References: Dimension.Stock Item
	3		Quantity On Hand	int				Quantity on hand
Quantity on hand
	4		Bin Location	nvarchar(20)				Bin location (where is this stock in the warehouse)
Bin location (where is this stock in the warehouse)
	5		Last Stocktake Quantity	int				Quantity present at last stocktake
Quantity present at last stocktake
	6		Last Cost Price	decimal(18, 2)				Unit cost when the stock item was last purchased
Unit cost when the stock item was last purchased
	7		Reorder Level	int				Quantity below which reordering should take place
Quantity below which reordering should take place
	8		Target Stock Level	int				Typical stock level held
Typical stock level held
	9		Lineage Key	int				Lineage Key for the data load for this row
Lineage Key for the data load for this row

Relations

Foreign table		Primary table	Join	Title / Name / Description
Fact.Stock Holding		Dimension.Stock Item	Fact.Stock Holding.Stock Item Key = Dimension.Stock Item.Stock Item Key	FK_Fact_Stock_Holding_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Stock Holding.Stock Item Key = Dimension.Stock Item.Stock Item Key Name: FK_Fact_Stock_Holding_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key

Unique keys

	Key name	Columns	Description
	PK_Fact_Stock_Holding	Stock Holding Key	Primary key (nonclustered) constraint.
Primary key (nonclustered) constraint.

Uses

Name
Fact.Stock Holding
Dimension.Stock Item

Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59